'''
Created on May 2, 2011

@author: GSE
'''
import pymysql
import sys


conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='root', db='cr_database')
cur = conn.cursor()
#cur.execute("insert into cr_user(id,name,age) values (2,'John Pohl',46) ")

cur.execute("select * from cr_metadatavalue")

#cur.callproc("insertContent" , ("Test1","Test",11,"This is a test","Testentry",2011,"tt","none",1))
#conn.commit()

for r in cur:
    print r
    
print "done"
    

cur.close()
conn.close()